﻿CREATE TABLE [dbo].[ActeMedicale] (
    [IdActMedical]    INT             IDENTITY (1, 1) NOT NULL,
    [Cod]             VARCHAR (10)    NOT NULL,
    [Denumire]        VARCHAR (100)   NOT NULL,
    [Valoare]         DECIMAL (18, 2) NOT NULL,
    [IdTipActMedical] INT             NOT NULL,
    CONSTRAINT [PK_ActeMedicale] PRIMARY KEY CLUSTERED ([IdActMedical] ASC),
    CONSTRAINT [FK_ActeMedicale_TipActeMedicale] FOREIGN KEY ([IdTipActMedical]) REFERENCES [dbo].[TipActeMedicale] ([IdTipActMedical])
);

